package com.sky.handler;

import com.sky.constant.MessageConstant;
import com.sky.exception.BaseException;
import com.sky.result.Result;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.RestControllerAdvice;

import java.sql.SQLIntegrityConstraintViolationException;

/**
 * 全局异常处理器，处理项目中抛出的业务异常
 */
@RestControllerAdvice
@Slf4j
public class GlobalExceptionHandler {

    /**
     * 捕获业务异常
     * @param ex
     * @return
     */
    @ExceptionHandler
    public Result exceptionHandler(BaseException ex){
        log.error("异常信息：{}", ex.getMessage());
        return Result.error(ex.getMessage());
    }

    /**
     *  处理sql异常
     *  错误类型为：SQLIntegrityConstraintViolationException
     */
    @ExceptionHandler
    public Result SqlexceptionHandler(SQLIntegrityConstraintViolationException exception) {

        String message = exception.getMessage();
        log.error(message);

        //统一响应结果
//        Duplicate entry 'zhagnsan' for key 'employee.idx_username'
        //当异常信息不包含：Duplicate entry，时，返回未知异常
        if (!message.contains("Duplicate entry")){
            return Result.error(message);
        }
        //获取异常信息的第三个参数
        String username = message.split(" ")[2];

        message = username + MessageConstant.ALREADY_EXISTS;

        return Result.error(message);

    }

}
